﻿use employees
go
------------------1----------------------------------------------------------------
/*Select all department's cities*/
SELECT 
[Dept].[City] 
FROM [dbo].[Dept] 
ORDER BY [Dept].[City] 

SELECT 
[Dept].[City]
FROM [dbo].[Dept] 
GROUP BY [Dept].[City]